﻿CREATE TABLE [dbo].[t_ContractHolder] (
    [ID]             INT           IDENTITY (1, 1) NOT NULL,
    [DealerID]       INT           NULL,
    [Name]           VARCHAR (64)  NULL,
    [Nick]           VARCHAR (32)  NULL,
    [ConditionsCode] CHAR (2)      NOT NULL,
    [Street]         VARCHAR (64)  NULL,
    [City]           VARCHAR (64)  NULL,
    [State]          CHAR (2)      NULL,
    [Zip]            VARCHAR (50)  NULL,
    [ContactName]    VARCHAR (64)  NULL,
    [ContactEmail]   VARCHAR (64)  NULL,
    [ContactPhone]   VARCHAR (32)  NULL,
    [ContactFax]     VARCHAR (32)  NULL,
    [AgreementDate]  SMALLDATETIME NULL
);

